﻿CREATE TABLE [dbo].[BugetConturi] (
    [IDBuget]     INT             IDENTITY (1, 1) NOT NULL,
    [Data]        DATETIME        NOT NULL,
    [Cont]        [dbo].[TipCont] NOT NULL,
    [Previzionat] DECIMAL (18, 2) CONSTRAINT [DF_BugetConturi_Previzionat] DEFAULT ((0)) NOT NULL,
    [Realizat]    DECIMAL (18, 2) CONSTRAINT [DF_BugetConturi_Realizat] DEFAULT ((0)) NOT NULL,
    [CodUnitate]  SMALLINT        NOT NULL,
    CONSTRAINT [PK_BugetConturi] PRIMARY KEY CLUSTERED ([IDBuget] ASC),
    CONSTRAINT [FK_BugetConturi_Conturi] FOREIGN KEY ([Cont], [CodUnitate]) REFERENCES [dbo].[Conturi] ([Cont], [CodUnitate])
);

